﻿CREATE TABLE [dbo].[PurchaseOrderItem] (
    [Id]                  UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [PurchaseOrderId]     UNIQUEIDENTIFIER NOT NULL,
    [TenderBidderQuoteId] UNIQUEIDENTIFIER NULL,
    [OrderRequestItemId]  UNIQUEIDENTIFIER NULL,
    [UnitMessureId]       UNIQUEIDENTIFIER NULL,
    [ProjectNoId]         UNIQUEIDENTIFIER NULL,
    [Quantity]            INT              NOT NULL,
    [UnitPrice]           FLOAT            NOT NULL,
    [TotalPrice]          MONEY            NOT NULL,
    [BudgetLineId]        UNIQUEIDENTIFIER NULL,
    [Remarks]             NTEXT            NULL
);

